/****** Object:  Stored Procedure [dbo].spChiTietPhieuNhapUpdate Script Date: 6/12/2012 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[spChiTietPhieuNhapUpdate]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
	DROP PROCEDURE [dbo].[spChiTietPhieuNhapUpdate]
GO

/******************************************************************************
**		Change History
*******************************************************************************
**		Date:		Author:					Description:
**		--------	--------				-----------------------------------
**		14/06/2012	SongTM					Innit created
*******************************************************************************/

CREATE PROCEDURE [dbo].[spChiTietPhieuNhapUpdate]
(
	@MaCTPN nvarchar(12),
	@SoPN nvarchar(14),
	@MaLuuKho int,
	@DonGia int,
	@SoLuong int
)

WITH ENCRYPTION

AS

SET NOCOUNT ON

UPDATE [tbl_ChiTietPhieuNhap]
SET [SoPN] = @SoPN,
	[MaLuuKho] = @MaLuuKho,
	[DonGia] = @DonGia,
	[SoLuong] = @SoLuong
WHERE	[MaCTPN] = @MaCTPN
GO
--GRANT EXECUTE ON [dbo].[spChiTietPhieuNhapUpdate] TO [sa]
--GO
